package com.work.service;

import com.work.bean.Student;
import com.work.bean.StudentDTO;

import java.util.List;

public interface StudentService {

    //插入方法
    public boolean insertService(Student stu) throws Exception;

    //修改方法
    public boolean uptStu(Student stu) throws Exception;

    //删除方法
    public boolean delStu(int sid) throws Exception;

    //全查询方法
    public List<Student> selectAll() throws Exception;

    //查询名字
    public List<String> findSname() throws Exception;

    //根据id查信息
    public Student findStuById(String sid) throws Exception;

    //查询人数（一行一列）
    public int findCount() throws Exception;

    //动态查询
    public List<Student> findPramStu(String sid, String sname, String ssex) throws Exception;

    //连表模糊查询
    public List<Student> findScoreStu(StudentDTO studentDTO) throws Exception;
}
